Highlighted in yellow:
Target Spending: Hoping close to Customer Left Year Group <=2
Historical Spending: Use as baseline, ideally not less than before
Approximately:
55,984 X Assume Response Rate X $1,045 + 2,030 X Assume Response Rate X $599 = Expected Revenue
Expected Revenue Details could be using QUANTILE_GRP.
Rencency: Time since last purchase
Frequency: Store Visit
Monetary: Spending Amount
Remarks: Orders actually mean store visit.
Highlighted in yellow:
Total No. of Customers available to contact.
Historical Spending: Use as baseline, ideally not less than before
Approximately:
Before
55,984 X Assume Response Rate X $1,045 + 2,030 X Assume Response Rate X $599 = Expected Revenue
After
46,988 X Assume Response Rate X $1,018 + 1,684 X Assume Response Rate X $599 = Expected Revenue
Expected Revenue Details could be using QUANTILE_GRP.